package com.ruoyi.system.mapper;


import com.ruoyi.system.domain.DataStatistics;
import com.ruoyi.system.domain.Dept;
import com.ruoyi.system.domain.EpmInformationHistory;
import com.ruoyi.system.domain.vo.Datastatisticsvo;
import com.ruoyi.system.domain.vo.DeptVo;
import com.ruoyi.system.domain.vo.EpmInformationHistoryVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.poi.ss.formula.functions.T;
import org.apache.xmlbeans.impl.xb.xsdschema.Public;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;


@Transactional(rollbackFor = Exception.class)
@Repository
public interface EmpcountMapper  {
    List<Datastatisticsvo> findUserCounts();
    List<Datastatisticsvo> findUserCounts2(@Param("date")String date);
//    将处理后的数据写入数据库
    int insertHistorycount(@Param("list")List<Datastatisticsvo> list, @Param("date")String date);

    List<EpmInformationHistoryVo> EmpOps(@Param("range")Integer range);

    List<DeptVo> findUserCountsByTime(@Param("minTime")Integer minTime,
                                      @Param("maxTime")Integer maxTime,
                                      @Param("deptId")Long deptId);

    List<Datastatisticsvo> countByGender();
    List<Datastatisticsvo> countByEducation();
    List<Datastatisticsvo> countByRegion();

    List<Datastatisticsvo> getGangweiList();

    List<Datastatisticsvo> countByAge();
//    List<Datastatisticsvo> countByType();
}
